﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_GetEnterpriseByName')
	BEGIN
		DROP  Procedure  [esf_sso].P_GetEnterpriseByName
	END

GO

-- [esf_sso].P_GetEnterpriseByName 'Lateckno'

CREATE Procedure [esf_sso].P_GetEnterpriseByName
	@pName		VARCHAR (60)
AS

	SELECT * FROM [esf_sso].VEnterprise WHERE Ent_Name = @pName

GO